Category Filter - (%20Linux)

(default) 8 queries took 85 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `comments`11112
2DESCRIBE `tags`2225
3DESCRIBE `categories`222
4DESCRIBE `posts_tags`221
5DESCRIBE `categories_posts`222
6SELECT Post.* FROM posts Post, categories_posts pc, categories c WHERE c.category = ('%20Linux') AND c.id = pc.category_id AND pc.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC0020
7SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category151514
8SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag494919